package com.stu.service;

import com.stu.po.Students;
import com.stu.tools.ReData;
import com.stu.vo.ExcelData;

import java.sql.SQLException;
import java.util.List;

public interface ExcelService {
    public void test();

    public ReData dataSynthesis(List<ExcelData> list) throws Exception;

    void stuAdd(List<Students> list) throws SQLException;

    public void collegeCheck(String data) throws Exception;

    public void majorCheck(String data) throws Exception;

    public void stuIdCheck(Integer data) throws Exception;

    public void classCheck(String data) throws Exception;

    public void dataCheck(ExcelData data) throws Exception;

    public Integer getCollege(String collegeName) throws Exception;

    public Integer getMajor(String majorName,Integer collegeId) throws Exception;

    public Integer getClass(String className,Integer majorId) throws Exception;

}
